/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : SQL Server
 Source Server Version : 15002000
 Source Host           : localhost:1433
 Source Catalog        : article
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 15002000
 File Encoding         : 65001

 Date: 22/04/2021 16:48:17
*/


-- ----------------------------
-- Table structure for articles
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[articles]') AND type IN ('U'))
	DROP TABLE [dbo].[articles]
GO

CREATE TABLE [dbo].[articles] (
  [ID] int  IDENTITY(1,1) NOT NULL,
  [title] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [time] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [content] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [type] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [img] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [jieshao] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [zuozhe] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[articles] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of articles
-- ----------------------------
SET IDENTITY_INSERT [dbo].[articles] ON
GO

INSERT INTO [dbo].[articles] ([ID], [title], [time], [content], [type], [img], [jieshao], [zuozhe]) VALUES (N'1', N'钱塘湖春行 白居易', NULL, N'孤山寺北贾亭西，水面初平云脚低。
 几处早莺争暖树，谁家新燕啄春泥。
 乱花渐欲迷人眼，浅草才能没马蹄。
 最爱湖东行不足，绿杨阴里白沙堤。', N'诗词        ', N'images/qthcx.png', NULL, NULL)
GO

INSERT INTO [dbo].[articles] ([ID], [title], [time], [content], [type], [img], [jieshao], [zuozhe]) VALUES (N'2', N'木兰花令·拟古决绝词', NULL, N'人生若只如初见，何事秋风悲画扇。
等闲变却故人心，却道故人心易变。
骊山语罢清宵半，泪雨零铃终不怨。
何如薄幸锦衣郎，比翼连枝当日愿。 ', N'诗词', N'images/ngjjc.png', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[articles] OFF
GO


-- ----------------------------
-- Primary Key structure for table articles
-- ----------------------------
ALTER TABLE [dbo].[articles] ADD CONSTRAINT [PK_dbo.articles] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

